
/****** Object:  Table [dbo].[flights] --- SIN<->PEK JUN,JUL ----- ******/
INSERT INTO [dbo].[Flights]([DepartureAirport],[ArrivalAirport],[DepartureDateTime],[ArrivalDateTime],[DepartureTerminal],[ArrivalTerminal],[Distance],[TaxSurcharge],[FlightStatus],[AircraftId],[FlightCode])
VALUES
('SIN','PEK','2012-06-02 08:00:00','2012-06-02 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP601'),
('SIN','PEK','2012-06-02 15:00:00','2012-06-02 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP602'),
('SIN','PEK','2012-06-04 08:00:00','2012-06-04 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP603'),
('SIN','PEK','2012-06-04 15:00:00','2012-06-04 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP604'),
('SIN','PEK','2012-06-06 08:00:00','2012-06-06 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP605'),
('SIN','PEK','2012-06-06 15:00:00','2012-06-06 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP606'),
('SIN','PEK','2012-06-08 08:00:00','2012-06-08 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP607'),
('SIN','PEK','2012-06-08 15:00:00','2012-06-08 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP608'),
('SIN','PEK','2012-06-10 08:00:00','2012-06-10 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP609'),
('SIN','PEK','2012-06-10 15:00:00','2012-06-10 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP610'),

('SIN','PEK','2012-06-12 08:00:00','2012-06-12 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP611'),
('SIN','PEK','2012-06-12 15:00:00','2012-06-12 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP612'),
('SIN','PEK','2012-06-14 08:00:00','2012-06-14 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP613'),
('SIN','PEK','2012-06-14 15:00:00','2012-06-14 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP614'),
('SIN','PEK','2012-06-16 08:00:00','2012-06-16 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP615'),
('SIN','PEK','2012-06-16 15:00:00','2012-06-16 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP616'),
('SIN','PEK','2012-06-18 08:00:00','2012-06-18 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP617'),
('SIN','PEK','2012-06-18 15:00:00','2012-06-18 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP618'),
('SIN','PEK','2012-06-20 08:00:00','2012-06-20 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP619'),
('SIN','PEK','2012-06-20 15:00:00','2012-06-20 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP620'),

('SIN','PEK','2012-06-22 08:00:00','2012-06-22 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP621'),
('SIN','PEK','2012-06-22 15:00:00','2012-06-22 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP622'),
('SIN','PEK','2012-06-24 08:00:00','2012-06-24 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP623'),
('SIN','PEK','2012-06-24 15:00:00','2012-06-24 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP624'),
('SIN','PEK','2012-06-26 08:00:00','2012-06-26 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP625'),
('SIN','PEK','2012-06-26 15:00:00','2012-06-26 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP626'),
('SIN','PEK','2012-06-28 08:00:00','2012-06-28 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP627'),
('SIN','PEK','2012-06-28 15:00:00','2012-06-28 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP628'),
('SIN','PEK','2012-06-30 08:00:00','2012-06-30 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP629'),
('SIN','PEK','2012-06-30 15:00:00','2012-06-30 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP630'),

('PEK','SIN','2012-06-02 08:00:00','2012-06-02 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS601'),
('PEK','SIN','2012-06-02 15:00:00','2012-06-02 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS602'),
('PEK','SIN','2012-06-04 08:00:00','2012-06-04 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS603'),
('PEK','SIN','2012-06-04 15:00:00','2012-06-04 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS604'),
('PEK','SIN','2012-06-06 08:00:00','2012-06-06 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS605'),
('PEK','SIN','2012-06-06 15:00:00','2012-06-06 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS606'),
('PEK','SIN','2012-06-08 08:00:00','2012-06-08 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS607'),
('PEK','SIN','2012-06-08 15:00:00','2012-06-08 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS608'),
('PEK','SIN','2012-06-10 08:00:00','2012-06-10 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS609'),
('PEK','SIN','2012-06-10 15:00:00','2012-06-10 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS610'),

('PEK','SIN','2012-06-12 08:00:00','2012-06-12 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS611'),
('PEK','SIN','2012-06-12 15:00:00','2012-06-12 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS612'),
('PEK','SIN','2012-06-14 08:00:00','2012-06-14 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS613'),
('PEK','SIN','2012-06-14 15:00:00','2012-06-14 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS614'),
('PEK','SIN','2012-06-16 08:00:00','2012-06-16 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS615'),
('PEK','SIN','2012-06-16 15:00:00','2012-06-16 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS616'),
('PEK','SIN','2012-06-18 08:00:00','2012-06-18 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS617'),
('PEK','SIN','2012-06-18 15:00:00','2012-06-18 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS618'),
('PEK','SIN','2012-06-20 08:00:00','2012-06-20 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS619'),
('PEK','SIN','2012-06-20 15:00:00','2012-06-20 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS620'),

('PEK','SIN','2012-06-22 08:00:00','2012-06-22 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS621'),
('PEK','SIN','2012-06-22 15:00:00','2012-06-22 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS622'),
('PEK','SIN','2012-06-24 08:00:00','2012-06-24 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS623'),
('PEK','SIN','2012-06-24 15:00:00','2012-06-24 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS624'),
('PEK','SIN','2012-06-26 08:00:00','2012-06-26 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS625'),
('PEK','SIN','2012-06-26 15:00:00','2012-06-26 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS626'),
('PEK','SIN','2012-06-28 08:00:00','2012-06-28 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS627'),
('PEK','SIN','2012-06-28 15:00:00','2012-06-28 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS628'),
('PEK','SIN','2012-06-30 08:00:00','2012-06-30 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS629'),
('PEK','SIN','2012-06-30 15:00:00','2012-06-30 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS630'),

('SIN','PEK','2012-07-02 08:00:00','2012-07-02 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP701'),
('SIN','PEK','2012-07-02 15:00:00','2012-07-02 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP702'),
('SIN','PEK','2012-07-04 08:00:00','2012-07-04 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP703'),
('SIN','PEK','2012-07-04 15:00:00','2012-07-04 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP704'),
('SIN','PEK','2012-07-06 08:00:00','2012-07-06 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP705'),
('SIN','PEK','2012-07-06 15:00:00','2012-07-06 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP706'),
('SIN','PEK','2012-07-08 08:00:00','2012-07-08 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP707'),
('SIN','PEK','2012-07-08 15:00:00','2012-07-08 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP708'),
('SIN','PEK','2012-07-10 08:00:00','2012-07-10 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP709'),
('SIN','PEK','2012-07-10 15:00:00','2012-07-10 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP710'),

('SIN','PEK','2012-07-12 08:00:00','2012-07-12 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP711'),
('SIN','PEK','2012-07-12 15:00:00','2012-07-12 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP712'),
('SIN','PEK','2012-07-14 08:00:00','2012-07-14 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP713'),
('SIN','PEK','2012-07-14 15:00:00','2012-07-14 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP714'),
('SIN','PEK','2012-07-16 08:00:00','2012-07-16 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP715'),
('SIN','PEK','2012-07-16 15:00:00','2012-07-16 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP716'),
('SIN','PEK','2012-07-18 08:00:00','2012-07-18 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP717'),
('SIN','PEK','2012-07-18 15:00:00','2012-07-18 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP718'),
('SIN','PEK','2012-07-20 08:00:00','2012-07-20 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP719'),
('SIN','PEK','2012-07-20 15:00:00','2012-07-20 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP720'),

('SIN','PEK','2012-07-22 08:00:00','2012-07-22 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP721'),
('SIN','PEK','2012-07-22 15:00:00','2012-07-22 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP722'),
('SIN','PEK','2012-07-24 08:00:00','2012-07-24 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP723'),
('SIN','PEK','2012-07-24 15:00:00','2012-07-24 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP724'),
('SIN','PEK','2012-07-26 08:00:00','2012-07-26 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP725'),
('SIN','PEK','2012-07-26 15:00:00','2012-07-26 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP726'),
('SIN','PEK','2012-07-28 08:00:00','2012-07-28 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP727'),
('SIN','PEK','2012-07-28 15:00:00','2012-07-28 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP728'),
('SIN','PEK','2012-07-30 08:00:00','2012-07-30 13:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP729'),
('SIN','PEK','2012-07-30 15:00:00','2012-07-30 20:00:00','SIN1','PEK2','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SP730'),

('PEK','SIN','2012-07-02 08:00:00','2012-07-02 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS701'),
('PEK','SIN','2012-07-02 15:00:00','2012-07-02 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS702'),
('PEK','SIN','2012-07-04 08:00:00','2012-07-04 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS703'),
('PEK','SIN','2012-07-04 15:00:00','2012-07-04 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS704'),
('PEK','SIN','2012-07-06 08:00:00','2012-07-06 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS705'),
('PEK','SIN','2012-07-06 15:00:00','2012-07-06 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS706'),
('PEK','SIN','2012-07-08 08:00:00','2012-07-08 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS707'),
('PEK','SIN','2012-07-08 15:00:00','2012-07-08 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS708'),
('PEK','SIN','2012-07-10 08:00:00','2012-07-10 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS709'),
('PEK','SIN','2012-07-10 15:00:00','2012-07-10 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS710'),

('PEK','SIN','2012-07-12 08:00:00','2012-07-12 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS711'),
('PEK','SIN','2012-07-12 15:00:00','2012-07-12 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS712'),
('PEK','SIN','2012-07-14 08:00:00','2012-07-14 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS713'),
('PEK','SIN','2012-07-14 15:00:00','2012-07-14 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS714'),
('PEK','SIN','2012-07-16 08:00:00','2012-07-16 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS715'),
('PEK','SIN','2012-07-16 15:00:00','2012-07-16 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS716'),
('PEK','SIN','2012-07-18 08:00:00','2012-07-18 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS717'),
('PEK','SIN','2012-07-18 15:00:00','2012-07-18 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS718'),
('PEK','SIN','2012-07-20 08:00:00','2012-07-20 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS719'),
('PEK','SIN','2012-07-20 15:00:00','2012-07-20 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS720'),

('PEK','SIN','2012-07-22 08:00:00','2012-07-22 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS721'),
('PEK','SIN','2012-07-22 15:00:00','2012-07-22 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS722'),
('PEK','SIN','2012-07-24 08:00:00','2012-07-24 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS723'),
('PEK','SIN','2012-07-24 15:00:00','2012-07-24 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS724'),
('PEK','SIN','2012-07-26 08:00:00','2012-07-26 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS725'),
('PEK','SIN','2012-07-26 15:00:00','2012-07-26 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS726'),
('PEK','SIN','2012-07-28 08:00:00','2012-07-28 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS727'),
('PEK','SIN','2012-07-28 15:00:00','2012-07-28 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS728'),
('PEK','SIN','2012-07-30 08:00:00','2012-07-30 13:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS729'),
('PEK','SIN','2012-07-30 15:00:00','2012-07-30 20:00:00','PEK2','SIN1','4742 KM','350','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'PS730');

/****** Object:  Table [dbo].[flights] --- SIN<->HKG JUN,JUL ----- ******/
INSERT INTO [dbo].[Flights]([DepartureAirport],[ArrivalAirport],[DepartureDateTime],[ArrivalDateTime],[DepartureTerminal],[ArrivalTerminal],[Distance],[TaxSurcharge],[FlightStatus],[AircraftId],[FlightCode])
VALUES
('SIN','HKG','2012-06-02 10:00:00','2012-06-02 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH601'),
('SIN','HKG','2012-06-02 15:00:00','2012-06-02 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH602'),
('SIN','HKG','2012-06-04 10:00:00','2012-06-04 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH603'),
('SIN','HKG','2012-06-04 15:00:00','2012-06-04 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH604'),
('SIN','HKG','2012-06-06 10:00:00','2012-06-06 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH605'),
('SIN','HKG','2012-06-06 15:00:00','2012-06-06 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH606'),
('SIN','HKG','2012-06-08 10:00:00','2012-06-08 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH607'),
('SIN','HKG','2012-06-08 15:00:00','2012-06-08 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH608'),
('SIN','HKG','2012-06-10 10:00:00','2012-06-10 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH609'),
('SIN','HKG','2012-06-10 15:00:00','2012-06-10 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH610'),

('SIN','HKG','2012-06-12 10:00:00','2012-06-12 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH611'),
('SIN','HKG','2012-06-12 15:00:00','2012-06-12 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH612'),
('SIN','HKG','2012-06-14 10:00:00','2012-06-14 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH613'),
('SIN','HKG','2012-06-14 15:00:00','2012-06-14 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH614'),
('SIN','HKG','2012-06-16 10:00:00','2012-06-16 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH615'),
('SIN','HKG','2012-06-16 15:00:00','2012-06-16 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH616'),
('SIN','HKG','2012-06-18 10:00:00','2012-06-18 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH617'),
('SIN','HKG','2012-06-18 15:00:00','2012-06-18 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH618'),
('SIN','HKG','2012-06-20 10:00:00','2012-06-20 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH619'),
('SIN','HKG','2012-06-20 15:00:00','2012-06-20 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH620'),

('SIN','HKG','2012-06-22 10:00:00','2012-06-22 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH621'),
('SIN','HKG','2012-06-22 15:00:00','2012-06-22 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH622'),
('SIN','HKG','2012-06-24 10:00:00','2012-06-24 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH623'),
('SIN','HKG','2012-06-24 15:00:00','2012-06-24 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH624'),
('SIN','HKG','2012-06-26 10:00:00','2012-06-26 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH625'),
('SIN','HKG','2012-06-26 15:00:00','2012-06-26 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH626'),
('SIN','HKG','2012-06-28 10:00:00','2012-06-28 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH627'),
('SIN','HKG','2012-06-28 15:00:00','2012-06-28 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH628'),
('SIN','HKG','2012-06-30 10:00:00','2012-06-30 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH629'),
('SIN','HKG','2012-06-30 15:00:00','2012-06-30 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH630'),

('HKG','SIN','2012-06-02 10:00:00','2012-06-02 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS601'),
('HKG','SIN','2012-06-02 15:00:00','2012-06-02 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS602'),
('HKG','SIN','2012-06-04 10:00:00','2012-06-04 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS603'),
('HKG','SIN','2012-06-04 15:00:00','2012-06-04 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS604'),
('HKG','SIN','2012-06-06 10:00:00','2012-06-06 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS605'),
('HKG','SIN','2012-06-06 15:00:00','2012-06-06 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS606'),
('HKG','SIN','2012-06-08 10:00:00','2012-06-08 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS607'),
('HKG','SIN','2012-06-08 15:00:00','2012-06-08 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS608'),
('HKG','SIN','2012-06-10 10:00:00','2012-06-10 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS609'),
('HKG','SIN','2012-06-10 15:00:00','2012-06-10 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS610'),

('HKG','SIN','2012-06-12 10:00:00','2012-06-12 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS611'),
('HKG','SIN','2012-06-12 15:00:00','2012-06-12 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS612'),
('HKG','SIN','2012-06-14 10:00:00','2012-06-14 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS613'),
('HKG','SIN','2012-06-14 15:00:00','2012-06-14 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS614'),
('HKG','SIN','2012-06-16 10:00:00','2012-06-16 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS615'),
('HKG','SIN','2012-06-16 15:00:00','2012-06-16 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS616'),
('HKG','SIN','2012-06-18 10:00:00','2012-06-18 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS617'),
('HKG','SIN','2012-06-18 15:00:00','2012-06-18 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS618'),
('HKG','SIN','2012-06-20 10:00:00','2012-06-20 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS619'),
('HKG','SIN','2012-06-20 15:00:00','2012-06-20 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS620'),

('HKG','SIN','2012-06-22 10:00:00','2012-06-22 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS621'),
('HKG','SIN','2012-06-22 15:00:00','2012-06-22 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS622'),
('HKG','SIN','2012-06-24 10:00:00','2012-06-24 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS623'),
('HKG','SIN','2012-06-24 15:00:00','2012-06-24 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS624'),
('HKG','SIN','2012-06-26 10:00:00','2012-06-26 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS625'),
('HKG','SIN','2012-06-26 15:00:00','2012-06-26 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS626'),
('HKG','SIN','2012-06-28 10:00:00','2012-06-28 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS627'),
('HKG','SIN','2012-06-28 15:00:00','2012-06-28 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS628'),
('HKG','SIN','2012-06-30 10:00:00','2012-06-30 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS629'),
('HKG','SIN','2012-06-30 15:00:00','2012-06-30 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS630'),

('SIN','HKG','2012-07-02 10:00:00','2012-07-02 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH701'),
('SIN','HKG','2012-07-02 15:00:00','2012-07-02 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH702'),
('SIN','HKG','2012-07-04 10:00:00','2012-07-04 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH703'),
('SIN','HKG','2012-07-04 15:00:00','2012-07-04 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH704'),
('SIN','HKG','2012-07-06 10:00:00','2012-07-06 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH705'),
('SIN','HKG','2012-07-06 15:00:00','2012-07-06 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH706'),
('SIN','HKG','2012-07-08 10:00:00','2012-07-08 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH707'),
('SIN','HKG','2012-07-08 15:00:00','2012-07-08 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH708'),
('SIN','HKG','2012-07-10 10:00:00','2012-07-10 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH709'),
('SIN','HKG','2012-07-10 15:00:00','2012-07-10 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH710'),

('SIN','HKG','2012-07-12 10:00:00','2012-07-12 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH711'),
('SIN','HKG','2012-07-12 15:00:00','2012-07-12 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH712'),
('SIN','HKG','2012-07-14 10:00:00','2012-07-14 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH713'),
('SIN','HKG','2012-07-14 15:00:00','2012-07-14 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH714'),
('SIN','HKG','2012-07-16 10:00:00','2012-07-16 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH715'),
('SIN','HKG','2012-07-16 15:00:00','2012-07-16 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH716'),
('SIN','HKG','2012-07-18 10:00:00','2012-07-18 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH717'),
('SIN','HKG','2012-07-18 15:00:00','2012-07-18 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH718'),
('SIN','HKG','2012-07-20 10:00:00','2012-07-20 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH719'),
('SIN','HKG','2012-07-20 15:00:00','2012-07-20 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH720'),

('SIN','HKG','2012-07-22 10:00:00','2012-07-22 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH721'),
('SIN','HKG','2012-07-22 15:00:00','2012-07-22 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH722'),
('SIN','HKG','2012-07-24 10:00:00','2012-07-24 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH723'),
('SIN','HKG','2012-07-24 15:00:00','2012-07-24 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH724'),
('SIN','HKG','2012-07-26 10:00:00','2012-07-26 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH725'),
('SIN','HKG','2012-07-26 15:00:00','2012-07-26 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH726'),
('SIN','HKG','2012-07-28 10:00:00','2012-07-28 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH727'),
('SIN','HKG','2012-07-28 15:00:00','2012-07-28 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH728'),
('SIN','HKG','2012-07-30 10:00:00','2012-07-30 13:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH729'),
('SIN','HKG','2012-07-30 15:00:00','2012-07-30 18:00:00','SIN1','HKG2','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'SH730'),

('HKG','SIN','2012-07-02 10:00:00','2012-07-02 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS701'),
('HKG','SIN','2012-07-02 15:00:00','2012-07-02 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS702'),
('HKG','SIN','2012-07-04 10:00:00','2012-07-04 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS703'),
('HKG','SIN','2012-07-04 15:00:00','2012-07-04 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS704'),
('HKG','SIN','2012-07-06 10:00:00','2012-07-06 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS705'),
('HKG','SIN','2012-07-06 15:00:00','2012-07-06 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS706'),
('HKG','SIN','2012-07-08 10:00:00','2012-07-08 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS707'),
('HKG','SIN','2012-07-08 15:00:00','2012-07-08 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS708'),
('HKG','SIN','2012-07-10 10:00:00','2012-07-10 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS709'),
('HKG','SIN','2012-07-10 15:00:00','2012-07-10 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS710'),

('HKG','SIN','2012-07-12 10:00:00','2012-07-12 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS711'),
('HKG','SIN','2012-07-12 15:00:00','2012-07-12 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS712'),
('HKG','SIN','2012-07-14 10:00:00','2012-07-14 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS713'),
('HKG','SIN','2012-07-14 15:00:00','2012-07-14 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS714'),
('HKG','SIN','2012-07-16 10:00:00','2012-07-16 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS715'),
('HKG','SIN','2012-07-16 15:00:00','2012-07-16 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS716'),
('HKG','SIN','2012-07-18 10:00:00','2012-07-18 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS717'),
('HKG','SIN','2012-07-18 15:00:00','2012-07-18 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS718'),
('HKG','SIN','2012-07-20 10:00:00','2012-07-20 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS719'),
('HKG','SIN','2012-07-20 15:00:00','2012-07-20 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS720'),

('HKG','SIN','2012-07-22 10:00:00','2012-07-22 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS721'),
('HKG','SIN','2012-07-22 15:00:00','2012-07-22 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS722'),
('HKG','SIN','2012-07-24 10:00:00','2012-07-24 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS723'),
('HKG','SIN','2012-07-24 15:00:00','2012-07-24 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS724'),
('HKG','SIN','2012-07-26 10:00:00','2012-07-26 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS725'),
('HKG','SIN','2012-07-26 15:00:00','2012-07-26 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS726'),
('HKG','SIN','2012-07-28 10:00:00','2012-07-28 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS727'),
('HKG','SIN','2012-07-28 15:00:00','2012-07-28 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS728'),
('HKG','SIN','2012-07-30 10:00:00','2012-07-30 13:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS729'),
('HKG','SIN','2012-07-30 15:00:00','2012-07-30 18:00:00','HKG2','SIN1','2569 KM','250','Booking',(SELECT aircraftId FROM [dbo].[aircrafts] WHERE ( AircraftName = 'Airbus 320')) ,'HS730');

/****** Object:  Table [dbo].[flightPrice]******/		   
	   
INSERT INTO [dbo].[FlightPrices]([FlightId],[Price],[SeatTypeCode])
SELECT
	[FlightId],'400','EC' FROM [dbo].[Flights] where ( [Distance] = '4742 KM'); 

INSERT INTO [dbo].[FlightPrices]([FlightId],[Price],[SeatTypeCode])
SELECT
	[FlightId],'600','BC' FROM [dbo].[Flights] where ( [Distance] = '4742 KM');
	
INSERT INTO [dbo].[FlightPrices]([FlightId],[Price],[SeatTypeCode])
SELECT
	[FlightId],'800','FC' FROM [dbo].[Flights] where ( [Distance] = '4742 KM');  

INSERT INTO [dbo].[FlightPrices]([FlightId],[Price],[SeatTypeCode])
SELECT
	[FlightId],'400','EC' FROM [dbo].[Flights] where ( [Distance] = '2569 KM'); 

INSERT INTO [dbo].[FlightPrices]([FlightId],[Price],[SeatTypeCode])
SELECT
	[FlightId],'600','BC' FROM [dbo].[Flights] where ( [Distance] = '2569 KM');
	
INSERT INTO [dbo].[FlightPrices]([FlightId],[Price],[SeatTypeCode])
SELECT
	[FlightId],'800','FC' FROM [dbo].[Flights] where ( [Distance] = '2569 KM');